SaEnrollRevenue 
Logical Entity Name  SaEnrollRevenue 
Default Table Name  SaEnrollRevenue 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

SaEnrollRevenue Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SaEnrollRevenueID(PK)    int  NO 
 
AdEnrollID    int  NO 
 
AcademicYear    numeric(3, 0)  NO 
 
AdTermID    int  YES 
 
SaBillCode    char(8)  NO 
 
BillingFrequency    char(1)  NO 
 
FutureRevenue    money  NO 
 
RevenueEarned    money  NO 
 
TotalRevenueUnits    numeric(8, 2)  NO 
 
RevenueUnitsEarned    numeric(8, 2)  NO 
 
ExceptionCode    varchar(50)  YES 
 
LastEarnDate    datetime  YES 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID    int  NO 
 
ts    timestamp  NO 
 
SyCampusID    int  NO 
 
FullMonthAmount    money  NO 
 
LastEarnAmount    money  NO 
 
PeriodBeginDate    datetime  YES 
 
PeriodEndDate    datetime  YES 
 
ManualOverride    bit  NO 
 
RevenueBasis    char(1)  YES 
 
ManualOverrideUnits    bit  YES 
 
AdClassSchedID(FK)    int  YES 
 
FaStudentAyPaymentPeriodId(FK)    int  YES 
 
AdFeesId(FK)    int  YES 
 
isFirstMonthPercentEarnCharge    bit  YES 
 
PercentRevBatchNo    char(8)  YES 
 

SaEnrollRevenue Primary and Unique Keys 
Key Name  Key Type  Keys 
SaEnrollRevenue_SyCampusID_SaEnrollRevenueID_U_N_IDX  Index  SyCampusID, SaEnrollRevenueID 
SaEnrollRevenue_SaEnrollRevenueID_U_C_IDX  PrimaryKey  SaEnrollRevenueID 

SaEnrollRevenue Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdClassSched  Non-Identifying  Zero or One to Zero or More  Fk_SaEnrollRevenue_AdClassSchedID_AdClassSched_AdClassSchedID      AdClassSchedID  NO  YES 
AdFees  Non-Identifying  Zero or One to Zero or More  FK_SaEnrollRevenue_AdFeesId_AdFees_AdFeesId      AdFeesId  NO  YES 
FaStudentAYPaymentPeriod  Non-Identifying  Zero or One to Zero or More  FK_SaEnrollRevenue_FaStudentAyPaymentPeriodId_FaStudentAyPaymentPeriod_FaStudentAyPaymentPeriodId      FaStudentAyPaymentPeriodId  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
SaEnrollRevenueChildTerm  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_SaEnrollRevenueID_SaEnrollRevenue_SaEnrollRevenueID        NO  YES 

SaEnrollRevenue Check Constraints 
Check Constraint Name  CheckConstraint 

SaEnrollRevenue Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

SaEnrollRevenue Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentRevenueSummary 
NO       
Physical (Microsoft SQL Server)
dbo.SaEnrollRevenue 
NO       

SaEnrollRevenue Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Revenue_GL_BankDeposit 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Student Accounts 

SaEnrollRevenue Data Movement Rules 
Name  Type  Rule Text/Value